package com.example.demo.pojo;

import java.util.ArrayList;
import java.util.List;

public class ShopExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public ShopExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andSpidIsNull() {
            addCriterion("spid is null");
            return (Criteria) this;
        }

        public Criteria andSpidIsNotNull() {
            addCriterion("spid is not null");
            return (Criteria) this;
        }

        public Criteria andSpidEqualTo(Integer value) {
            addCriterion("spid =", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidNotEqualTo(Integer value) {
            addCriterion("spid <>", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidGreaterThan(Integer value) {
            addCriterion("spid >", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidGreaterThanOrEqualTo(Integer value) {
            addCriterion("spid >=", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidLessThan(Integer value) {
            addCriterion("spid <", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidLessThanOrEqualTo(Integer value) {
            addCriterion("spid <=", value, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidIn(List<Integer> values) {
            addCriterion("spid in", values, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidNotIn(List<Integer> values) {
            addCriterion("spid not in", values, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidBetween(Integer value1, Integer value2) {
            addCriterion("spid between", value1, value2, "spid");
            return (Criteria) this;
        }

        public Criteria andSpidNotBetween(Integer value1, Integer value2) {
            addCriterion("spid not between", value1, value2, "spid");
            return (Criteria) this;
        }

        public Criteria andSpnumIsNull() {
            addCriterion("spnum is null");
            return (Criteria) this;
        }

        public Criteria andSpnumIsNotNull() {
            addCriterion("spnum is not null");
            return (Criteria) this;
        }

        public Criteria andSpnumEqualTo(Integer value) {
            addCriterion("spnum =", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumNotEqualTo(Integer value) {
            addCriterion("spnum <>", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumGreaterThan(Integer value) {
            addCriterion("spnum >", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumGreaterThanOrEqualTo(Integer value) {
            addCriterion("spnum >=", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumLessThan(Integer value) {
            addCriterion("spnum <", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumLessThanOrEqualTo(Integer value) {
            addCriterion("spnum <=", value, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumIn(List<Integer> values) {
            addCriterion("spnum in", values, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumNotIn(List<Integer> values) {
            addCriterion("spnum not in", values, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumBetween(Integer value1, Integer value2) {
            addCriterion("spnum between", value1, value2, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnumNotBetween(Integer value1, Integer value2) {
            addCriterion("spnum not between", value1, value2, "spnum");
            return (Criteria) this;
        }

        public Criteria andSpnameIsNull() {
            addCriterion("spname is null");
            return (Criteria) this;
        }

        public Criteria andSpnameIsNotNull() {
            addCriterion("spname is not null");
            return (Criteria) this;
        }

        public Criteria andSpnameEqualTo(String value) {
            addCriterion("spname =", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameNotEqualTo(String value) {
            addCriterion("spname <>", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameGreaterThan(String value) {
            addCriterion("spname >", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameGreaterThanOrEqualTo(String value) {
            addCriterion("spname >=", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameLessThan(String value) {
            addCriterion("spname <", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameLessThanOrEqualTo(String value) {
            addCriterion("spname <=", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameLike(String value) {
            addCriterion("spname like", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameNotLike(String value) {
            addCriterion("spname not like", value, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameIn(List<String> values) {
            addCriterion("spname in", values, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameNotIn(List<String> values) {
            addCriterion("spname not in", values, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameBetween(String value1, String value2) {
            addCriterion("spname between", value1, value2, "spname");
            return (Criteria) this;
        }

        public Criteria andSpnameNotBetween(String value1, String value2) {
            addCriterion("spname not between", value1, value2, "spname");
            return (Criteria) this;
        }

        public Criteria andSppriceIsNull() {
            addCriterion("spprice is null");
            return (Criteria) this;
        }

        public Criteria andSppriceIsNotNull() {
            addCriterion("spprice is not null");
            return (Criteria) this;
        }

        public Criteria andSppriceEqualTo(Double value) {
            addCriterion("spprice =", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceNotEqualTo(Double value) {
            addCriterion("spprice <>", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceGreaterThan(Double value) {
            addCriterion("spprice >", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceGreaterThanOrEqualTo(Double value) {
            addCriterion("spprice >=", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceLessThan(Double value) {
            addCriterion("spprice <", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceLessThanOrEqualTo(Double value) {
            addCriterion("spprice <=", value, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceIn(List<Double> values) {
            addCriterion("spprice in", values, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceNotIn(List<Double> values) {
            addCriterion("spprice not in", values, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceBetween(Double value1, Double value2) {
            addCriterion("spprice between", value1, value2, "spprice");
            return (Criteria) this;
        }

        public Criteria andSppriceNotBetween(Double value1, Double value2) {
            addCriterion("spprice not between", value1, value2, "spprice");
            return (Criteria) this;
        }

        public Criteria andSpmessageIsNull() {
            addCriterion("spmessage is null");
            return (Criteria) this;
        }

        public Criteria andSpmessageIsNotNull() {
            addCriterion("spmessage is not null");
            return (Criteria) this;
        }

        public Criteria andSpmessageEqualTo(String value) {
            addCriterion("spmessage =", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageNotEqualTo(String value) {
            addCriterion("spmessage <>", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageGreaterThan(String value) {
            addCriterion("spmessage >", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageGreaterThanOrEqualTo(String value) {
            addCriterion("spmessage >=", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageLessThan(String value) {
            addCriterion("spmessage <", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageLessThanOrEqualTo(String value) {
            addCriterion("spmessage <=", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageLike(String value) {
            addCriterion("spmessage like", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageNotLike(String value) {
            addCriterion("spmessage not like", value, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageIn(List<String> values) {
            addCriterion("spmessage in", values, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageNotIn(List<String> values) {
            addCriterion("spmessage not in", values, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageBetween(String value1, String value2) {
            addCriterion("spmessage between", value1, value2, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpmessageNotBetween(String value1, String value2) {
            addCriterion("spmessage not between", value1, value2, "spmessage");
            return (Criteria) this;
        }

        public Criteria andSpStIdIsNull() {
            addCriterion("sp_st_id is null");
            return (Criteria) this;
        }

        public Criteria andSpStIdIsNotNull() {
            addCriterion("sp_st_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpStIdEqualTo(Integer value) {
            addCriterion("sp_st_id =", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdNotEqualTo(Integer value) {
            addCriterion("sp_st_id <>", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdGreaterThan(Integer value) {
            addCriterion("sp_st_id >", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("sp_st_id >=", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdLessThan(Integer value) {
            addCriterion("sp_st_id <", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdLessThanOrEqualTo(Integer value) {
            addCriterion("sp_st_id <=", value, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdIn(List<Integer> values) {
            addCriterion("sp_st_id in", values, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdNotIn(List<Integer> values) {
            addCriterion("sp_st_id not in", values, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdBetween(Integer value1, Integer value2) {
            addCriterion("sp_st_id between", value1, value2, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpStIdNotBetween(Integer value1, Integer value2) {
            addCriterion("sp_st_id not between", value1, value2, "spStId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdIsNull() {
            addCriterion("sp_su_id is null");
            return (Criteria) this;
        }

        public Criteria andSpSuIdIsNotNull() {
            addCriterion("sp_su_id is not null");
            return (Criteria) this;
        }

        public Criteria andSpSuIdEqualTo(Integer value) {
            addCriterion("sp_su_id =", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdNotEqualTo(Integer value) {
            addCriterion("sp_su_id <>", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdGreaterThan(Integer value) {
            addCriterion("sp_su_id >", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("sp_su_id >=", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdLessThan(Integer value) {
            addCriterion("sp_su_id <", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdLessThanOrEqualTo(Integer value) {
            addCriterion("sp_su_id <=", value, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdIn(List<Integer> values) {
            addCriterion("sp_su_id in", values, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdNotIn(List<Integer> values) {
            addCriterion("sp_su_id not in", values, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdBetween(Integer value1, Integer value2) {
            addCriterion("sp_su_id between", value1, value2, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpSuIdNotBetween(Integer value1, Integer value2) {
            addCriterion("sp_su_id not between", value1, value2, "spSuId");
            return (Criteria) this;
        }

        public Criteria andSpimageIsNull() {
            addCriterion("spimage is null");
            return (Criteria) this;
        }

        public Criteria andSpimageIsNotNull() {
            addCriterion("spimage is not null");
            return (Criteria) this;
        }

        public Criteria andSpimageEqualTo(String value) {
            addCriterion("spimage =", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageNotEqualTo(String value) {
            addCriterion("spimage <>", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageGreaterThan(String value) {
            addCriterion("spimage >", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageGreaterThanOrEqualTo(String value) {
            addCriterion("spimage >=", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageLessThan(String value) {
            addCriterion("spimage <", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageLessThanOrEqualTo(String value) {
            addCriterion("spimage <=", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageLike(String value) {
            addCriterion("spimage like", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageNotLike(String value) {
            addCriterion("spimage not like", value, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageIn(List<String> values) {
            addCriterion("spimage in", values, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageNotIn(List<String> values) {
            addCriterion("spimage not in", values, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageBetween(String value1, String value2) {
            addCriterion("spimage between", value1, value2, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpimageNotBetween(String value1, String value2) {
            addCriterion("spimage not between", value1, value2, "spimage");
            return (Criteria) this;
        }

        public Criteria andSpdiskIsNull() {
            addCriterion("spdisk is null");
            return (Criteria) this;
        }

        public Criteria andSpdiskIsNotNull() {
            addCriterion("spdisk is not null");
            return (Criteria) this;
        }

        public Criteria andSpdiskEqualTo(String value) {
            addCriterion("spdisk =", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskNotEqualTo(String value) {
            addCriterion("spdisk <>", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskGreaterThan(String value) {
            addCriterion("spdisk >", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskGreaterThanOrEqualTo(String value) {
            addCriterion("spdisk >=", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskLessThan(String value) {
            addCriterion("spdisk <", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskLessThanOrEqualTo(String value) {
            addCriterion("spdisk <=", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskLike(String value) {
            addCriterion("spdisk like", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskNotLike(String value) {
            addCriterion("spdisk not like", value, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskIn(List<String> values) {
            addCriterion("spdisk in", values, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskNotIn(List<String> values) {
            addCriterion("spdisk not in", values, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskBetween(String value1, String value2) {
            addCriterion("spdisk between", value1, value2, "spdisk");
            return (Criteria) this;
        }

        public Criteria andSpdiskNotBetween(String value1, String value2) {
            addCriterion("spdisk not between", value1, value2, "spdisk");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}